UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'RE5xiVM+2wKYP3Hqw0EuexAmb57JGvo4VrBUi9TUiYc=' 
WHERE 
  key_id = '8b62cae6e56de704b3bb6b7550ed37f9d2a8cdf506edd44781f8051d5e2b36ef' 
  AND (
    token = 'RE5xiVM+2wKYP3Hqw0EuexAmb57JGvo4VrBUi9TUiYc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047