UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MkZHOV2DcImZSwAbaEfKY7prXLat0r8j8Wm/S/3MHDA=' 
WHERE 
  key_id = '08d242738bb6556df2ec777bf33e6c90c963146f2eca26f972d83cc43b3dc1a6' 
  AND (
    token = 'MkZHOV2DcImZSwAbaEfKY7prXLat0r8j8Wm/S/3MHDA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032