UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Zqbrf9MyM09+h6XuuiQLGx8pip8Po7kMsxGJRm7QXGI=' 
WHERE 
  key_id = '7787b0c969502df351130f295f06c8f47a4d8e67fc080625f4d136c2b80e6d10' 
  AND (
    token = 'Zqbrf9MyM09+h6XuuiQLGx8pip8Po7kMsxGJRm7QXGI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00017