UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQVFGVCjr/6oK9rGFSWLeQ8z3VHMKSi2Bw3E6dtctkM='
WHERE
key_id = '7cd5fc400353f6a8dcc38579c2cb553c1a4b411074a3b56227f16408769df189'
AND (
token = 'LQVFGVCjr/6oK9rGFSWLeQ8z3VHMKSi2Bw3E6dtctkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)