UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o1uzcrx9D+btO8nYPO6nvHwezQ7Uc73FeoesgTtOcvY='
WHERE
key_id = 'b19197fe337675be8fa89f297a4d40a3b323b127292243a6772e5d73a0eb4060'
AND (
token = 'o1uzcrx9D+btO8nYPO6nvHwezQ7Uc73FeoesgTtOcvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)