UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sXCaRG3Le/5ZFah1NWdZ+eMWLCRwkbif1fOu9Wugmig='
WHERE
key_id = 'a539d6ae9c14640a4cac8107d4b6f7e54bff7bcd5d6b0c3250d4a38ed9d8d805'
AND (
token = 'sXCaRG3Le/5ZFah1NWdZ+eMWLCRwkbif1fOu9Wugmig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)