UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sAUuX9hrABTwNbuF8sr4crMICOBG9XaeqDf+Usjguvc='
WHERE
key_id = 'a188c9ca0ce1e513f6027baf304ab9745d41cc9ec21928c6c821307a8f099b44'
AND (
token = 'sAUuX9hrABTwNbuF8sr4crMICOBG9XaeqDf+Usjguvc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)