UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XrLojrm9xgxJSb6trnvIFVPNKmnw2GfnwIC6jiNXw2Q='
WHERE
key_id = '6fb17846b03f67a46f442537efbba7b44d45bc11cc98f4edd05f00acf0abdd8a'
AND (
token = 'XrLojrm9xgxJSb6trnvIFVPNKmnw2GfnwIC6jiNXw2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)