UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gpf49/XFGx6BVxJqT8O/f3nAxFofXcI3HKCsVWY3SbU='
WHERE
key_id = 'df49c9c3422cbd79ec89b8d48c3991a6c7b83e24e8fd3e641de285b170b9e5fb'
AND (
token = 'gpf49/XFGx6BVxJqT8O/f3nAxFofXcI3HKCsVWY3SbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)