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