UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'smId/PuE2vPe6FrB8e/pgmb1R1iT8OOvhvGQ63ZjAuE='
WHERE
key_id = 'ca70584ef37e1b5f4a92fb435569e313ed7a1f73e0b5dd8f03ffdfdd1321d16e'
AND (
token = 'smId/PuE2vPe6FrB8e/pgmb1R1iT8OOvhvGQ63ZjAuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)