UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KsGbYqaYOxRL0bsOdtZ6YSaonBs58eIHVQvk19PKTPI='
WHERE
key_id = '0b94f8f9aefd166652974aaebf1226b28c12a01a27d7f491439217ca9bf751f1'
AND (
token = 'KsGbYqaYOxRL0bsOdtZ6YSaonBs58eIHVQvk19PKTPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)