UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7JJcDBq5Hw4yMPebrb3lR84bgWw73G87Jpiv1cLvAqA='
WHERE
key_id = '170181e028081f04d839783f870b4820aa98eef9e3ea8f192334e6d0aece26d5'
AND (
token = '7JJcDBq5Hw4yMPebrb3lR84bgWw73G87Jpiv1cLvAqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)