UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1e9VLoo4yla14/kOEt6cdymTBI+TIwQU5SwMM1+WsvI='
WHERE
key_id = 'dd1d6016841eb01260894fda7dc9e7e3175b5da3e503d097f0964fb878c6357e'
AND (
token = '1e9VLoo4yla14/kOEt6cdymTBI+TIwQU5SwMM1+WsvI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)