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