UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Avzw3OXNTdHrQyhP6yoEWNIYkmvBuid73mK46regUBw='
WHERE
key_id = 'bbf98685bba8576ade4072bc53aefd54117bb7a532dde1e122e43023623fde3e'
AND (
token = 'Avzw3OXNTdHrQyhP6yoEWNIYkmvBuid73mK46regUBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)