UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gYyVSXxWCNyvhOZFtwirg62EizvuSwf/eaNVRCVn2Iw='
WHERE
key_id = '2ba1d41fc7ffe5c9e80df57589461a1d58bbfe481b18f194af962f37e4fbf1ba'
AND (
token = 'gYyVSXxWCNyvhOZFtwirg62EizvuSwf/eaNVRCVn2Iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)