UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQ5bTUs9xnnd91JwA1m0eTYdsJT88IeCJk4UFZ4//44='
WHERE
key_id = '6a9c9e1cabf1cbbd9fefd202329e6b024603b3ad7e43c96227db0eacdb42887a'
AND (
token = 'xQ5bTUs9xnnd91JwA1m0eTYdsJT88IeCJk4UFZ4//44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)