UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3yiHIwI0J9KX3vlKFfk6LGq007qAS+fabz529JnGVsY='
WHERE
key_id = '78ca34b8d0d361ccf349a4d648701bed5dcbd002f87df51400a4185f02a3b31a'
AND (
token = '3yiHIwI0J9KX3vlKFfk6LGq007qAS+fabz529JnGVsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)