UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCReWOSg7ZRA0CT4LQvRsyAJMYju2fE3KkluVJdlFws='
WHERE
key_id = '1384e00dacfda984b158cb378f6cd6535ccf0aa041bb60d5eaf915e6a0c563be'
AND (
token = 'gCReWOSg7ZRA0CT4LQvRsyAJMYju2fE3KkluVJdlFws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)