UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JMZl0JHi8d57HyfVzFYYFv2Zi6zHtvVHilasNWUcmSA='
WHERE
key_id = '15ff9a1019b00800da1027107fbac41e1d6289660f167c1723e8b5507d8a7c05'
AND (
token = 'JMZl0JHi8d57HyfVzFYYFv2Zi6zHtvVHilasNWUcmSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)