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