UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r5L3Y90o0dEpS23cINUZfOo2XA0eAtAy3hYJwr8awSk='
WHERE
key_id = '56ce5aaeb01667840aea9dadfb79f69dfdfa6d89a7b64b6e2fafb2c3b9355eb2'
AND (
token = 'r5L3Y90o0dEpS23cINUZfOo2XA0eAtAy3hYJwr8awSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)