UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o8Gk03HxXs5RzxLTxHdfiXdD5itZuwva3Y4e3EMl9/E='
WHERE
key_id = 'bf47c7c9f7c6e7504bd1793e4e93a4deafc3ccbc1c75d5c889e4e7de27931b50'
AND (
token = 'o8Gk03HxXs5RzxLTxHdfiXdD5itZuwva3Y4e3EMl9/E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)