UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8FcFUgu14yFBmfzYyRWa3NLT6Vv3EhT/PIWeIwHLog8='
WHERE
key_id = 'f574d8021a274ef08ffd91702328d4ac8e6862e3a5f1fca0a5711cf0e8be2724'
AND (
token = '8FcFUgu14yFBmfzYyRWa3NLT6Vv3EhT/PIWeIwHLog8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)