UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nuor2DKSYjTdjHe+HLABbF9tmosGIMJcR7VeSJM+02Y='
WHERE
key_id = 'cfaeba7740ff4dc9b3d05301103def1096c4a82185f805d93441b69990b98dfe'
AND (
token = 'Nuor2DKSYjTdjHe+HLABbF9tmosGIMJcR7VeSJM+02Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)