UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3M0U0MSEurhDrYlbA1wa7FHES9BqbhnDpdHRJ1JZO94='
WHERE
key_id = 'ef5c9a589ce4767ddb55e5d18ba4c867d4f746bf5c33d672c6298511a4989cbb'
AND (
token = '3M0U0MSEurhDrYlbA1wa7FHES9BqbhnDpdHRJ1JZO94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)