UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vnq9CtMIycHrAPmBsbAdRVXUHbqgZf1V/eXWk8PZAz8='
WHERE
key_id = 'e0a3b81e372cb4934ee29332b85ba6df48d8bb9737b127156a60bac7e39ddd71'
AND (
token = 'vnq9CtMIycHrAPmBsbAdRVXUHbqgZf1V/eXWk8PZAz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)