UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jq7J8MQ5DeLnv6T59wGLK2h1cbLvTV2wdHkEsYxPVD8='
WHERE
key_id = 'fa637a1a32c802c89d4734bc4aaf587e868e16e88caf58d224421a2130ce7325'
AND (
token = 'Jq7J8MQ5DeLnv6T59wGLK2h1cbLvTV2wdHkEsYxPVD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)