UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9eAiTHIhC9Lef0KMeTerJxIp3gnLXFp37fZT8anevjg='
WHERE
key_id = '4b18efbc03eeb14a3b449780d169d73cdca6d607fb34d06fe65f500bc54079e1'
AND (
token = '9eAiTHIhC9Lef0KMeTerJxIp3gnLXFp37fZT8anevjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)