UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd/hb7pi95eGNDSd1txtCVDtFpX6p+0PKg+4B3f9Z7XU='
WHERE
key_id = '7e471220ba9fb1b7a9ffe4c1e9e30f8effb79f11fea8a37a23a4127d9c19932a'
AND (
token = 'd/hb7pi95eGNDSd1txtCVDtFpX6p+0PKg+4B3f9Z7XU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)