UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KziaSlP5Qk7qFsBp/Hlsdlf34usfldYIvDFCrPD+RiU='
WHERE
key_id = 'fccb84aee144397196b06c0cb73eaaa027e473b268451066f3770acae3c0a6ec'
AND (
token = 'KziaSlP5Qk7qFsBp/Hlsdlf34usfldYIvDFCrPD+RiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)