UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NydX1MpAytdytg7nZQJdD8QAnrrvA1X/HIOsBqU/IfY='
WHERE
key_id = 'b08df2595cf89032560b26751bb112a05cd78561b487bc44ebf0c4bb457f5ae0'
AND (
token = 'NydX1MpAytdytg7nZQJdD8QAnrrvA1X/HIOsBqU/IfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)