UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8qEIvud3aJBr6kWyvLu889wEZI/GxUYjpUw/BuDKk5M='
WHERE
key_id = '179b8f2236d536f1abaf7e9500365a15cb25f6a567c09bdcc019d91fc2e21b01'
AND (
token = '8qEIvud3aJBr6kWyvLu889wEZI/GxUYjpUw/BuDKk5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)