UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '80qKoONSJMUKsQj6MnbcJ1egxF2vjM9B7jDP0Byrngo='
WHERE
key_id = 'b814fded1ddcf982c5d3ca829834dfd0c3c15197df930f72cf4350743bca6606'
AND (
token = '80qKoONSJMUKsQj6MnbcJ1egxF2vjM9B7jDP0Byrngo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)