UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XefRZnE2nVUeERrVrON6VdQzDcAMtxOTzqUsQmxng0M='
WHERE
key_id = '22774ef120fc34fb9254acb686a5a1a0b46db7c0155f5d6181284f137ec27a30'
AND (
token = 'XefRZnE2nVUeERrVrON6VdQzDcAMtxOTzqUsQmxng0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)