UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CUSaCfNU7sGeYfHqUuU7+ZAmEhcKNUlK10nn8/5Fkds='
WHERE
key_id = '1ca97e3bcb56fa05bba22c1f0d013a3308f94026702309a6e91da18a31997427'
AND (
token = 'CUSaCfNU7sGeYfHqUuU7+ZAmEhcKNUlK10nn8/5Fkds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)